<?php

use yii\db\Migration;

/**
 * Handles the creation of table `project_pre_evaluation_other_note`.
 */
class m171027_061706_create_project_pre_evaluation_other_note_table extends Migration
{
    /**
     * @inheritdoc
     * （混合类项目预评估信息）补充说明
     */
    public function up()
    {

        $this->createTable('project_pre_evaluation_other_note', [
            'id' => $this->bigPrimaryKey(),
            'legal' => $this->text()->notNull()->comment('法律依据'),
            'sell_plan' => $this->text()->notNull()->comment('处置方案'),
            'risk_point' => $this->text()->notNull()->comment('风险点'),
            'current_state' => $this->text()->notNull()->comment('承债人现状'),
            'other_problem' => $this->text()->notNull()->comment('其他问题'),
            'more_problem' => $this->text()->notNull()->comment('需再补充'),
            'created_at' => $this->timestamp(),
            'lock_user' => $this->integer()->comment('上锁用户'),
            'lock_timestamp' => $this->string()->comment('上锁时间'),
        ]);
    }

    /**
     * @inheritdoc
     */
    public function down()
    {
        $this->dropTable('project_pre_evaluation_other_note');
    }
}
